DROP TABLE IF EXISTS `sub_party_info`;

CREATE TABLE `sub_party_info` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `party_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `parent_id` bigint(20) NOT NULL DEFAULT '0',
  `parent_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `party_type` varchar(8) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DELIMITER $$

USE `elevators`$$

DROP TRIGGER /*!50032 IF EXISTS */ `party_insert`$$

CREATE
  /*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `party_insert` AFTER INSERT ON `party`
FOR EACH ROW BEGIN
  DELETE FROM sub_party_info;
  INSERT INTO sub_party_info
    SELECT
      a1.id,a1.party_name,a6.id parent_id,a6.party_name parent_name,a1.party_type
    FROM
      party a1 LEFT JOIN party a2
        ON a1.parent_id = a2.id
      LEFT JOIN party a3
        ON a2.parent_id = a3.id
      LEFT JOIN party a4
        ON a3.parent_id = a4.id
      LEFT JOIN party a5
        ON a4.parent_id = a5.id
      INNER JOIN party a6 ON
                            (a6.id = a1.parent_id
                             OR a6.id = a2.parent_id
                             OR a6.id = a3.parent_id
                             OR a6.id = a4.parent_id
                             OR a6.id = a5.parent_id
                             OR a6.id = a1.id);
END;
$$

DELIMITER ;

DELIMITER $$

USE `elevators`$$

DROP TRIGGER /*!50032 IF EXISTS */ `party_update`$$

CREATE
  /*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `party_update` AFTER UPDATE ON `party`
FOR EACH ROW BEGIN
  DELETE FROM sub_party_info;
  INSERT INTO sub_party_info
    SELECT
      a1.id,a1.party_name,a6.id parent_id,a6.party_name parent_name,a1.party_type
    FROM
      party a1 LEFT JOIN party a2
        ON a1.parent_id = a2.id
      LEFT JOIN party a3
        ON a2.parent_id = a3.id
      LEFT JOIN party a4
        ON a3.parent_id = a4.id
      LEFT JOIN party a5
        ON a4.parent_id = a5.id
      INNER JOIN party a6 ON
                            (a6.id = a1.parent_id
                             OR a6.id = a2.parent_id
                             OR a6.id = a3.parent_id
                             OR a6.id = a4.parent_id
                             OR a6.id = a5.parent_id
                             OR a6.id = a1.id);
END;
$$

DELIMITER ;

DELIMITER $$

USE `elevators`$$

DROP TRIGGER /*!50032 IF EXISTS */ `party_delete`$$

CREATE
  /*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `party_delete` AFTER DELETE ON `party`
FOR EACH ROW BEGIN
  DELETE FROM sub_party_info;
  INSERT INTO sub_party_info
    SELECT
      a1.id,a1.party_name,a6.id parent_id,a6.party_name parent_name,a1.party_type
    FROM
      party a1 LEFT JOIN party a2
        ON a1.parent_id = a2.id
      LEFT JOIN party a3
        ON a2.parent_id = a3.id
      LEFT JOIN party a4
        ON a3.parent_id = a4.id
      LEFT JOIN party a5
        ON a4.parent_id = a5.id
      INNER JOIN party a6 ON
                            (a6.id = a1.parent_id
                             OR a6.id = a2.parent_id
                             OR a6.id = a3.parent_id
                             OR a6.id = a4.parent_id
                             OR a6.id = a5.parent_id
                             OR a6.id = a1.id);
END;
$$

DELIMITER ;


DROP TABLE IF EXISTS `promotion_party_score`;
CREATE TABLE `promotion_party_score` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `PARTY_TYPE` varchar(8) COLLATE utf8_bin DEFAULT NULL,
  `ADD_SCORE` bigint(8) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DROP TABLE IF EXISTS `maint_fields`;

CREATE TABLE `maint_fields` (
  `ELEVATOR_TYPE` varchar(255) COLLATE utf8_bin NOT NULL,
  `MAINT_TYPE` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `ITEM` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `DEMAND` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `EN_ITEM` varchar(255) COLLATE utf8_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


DROP TABLE IF EXISTS `elevator_overtime`;

CREATE TABLE `elevator_overtime` (
  `elevator_id` bigint(20) NOT NULL,
  `overtime_date` varchar(20) NOT NULL,
  PRIMARY KEY (`elevator_id`,`overtime_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

DROP TABLE IF EXISTS `check_overtime_statistics`;

CREATE TABLE `check_overtime_statistics` (
  `year` VARCHAR(255) COLLATE utf8_bin NOT NULL,
  `quarter` VARCHAR(8) COLLATE utf8_bin NOT NULL,
  `party_id` VARCHAR(8) COLLATE utf8_bin NOT NULL,
  `party_name` VARCHAR(64) COLLATE utf8_bin,
  `check_num` VARCHAR(64) COLLATE utf8_bin,
  PRIMARY KEY (`year`,`quarter`,`party_id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


DROP TABLE IF EXISTS `implementation_statistics`;

CREATE TABLE `implementation_statistics` (
  `year` VARCHAR(8) COLLATE utf8_bin NOT NULL,
  `quarter` VARCHAR(8) COLLATE utf8_bin NOT NULL,
  `feedback_num` VARCHAR(8) COLLATE utf8_bin DEFAULT '0',
  `rescue_num` VARCHAR(8) COLLATE utf8_bin DEFAULT '0',
  `maint_num` VARCHAR(8) COLLATE utf8_bin DEFAULT '0',
  `inspection_num` VARCHAR(8) COLLATE utf8_bin DEFAULT '0',
  PRIMARY KEY (`year`,`quarter`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


DROP TABLE IF EXISTS `repair_statistics`;

CREATE TABLE `repair_statistics` (
  `year` VARCHAR(8) COLLATE utf8_bin NOT NULL,
  `quarter` VARCHAR(8) COLLATE utf8_bin NOT NULL,
  `party_id` VARCHAR(8) COLLATE utf8_bin DEFAULT '0',
  `party_name` VARCHAR(64) COLLATE utf8_bin DEFAULT '0',
  `repair_num` VARCHAR(8) COLLATE utf8_bin DEFAULT '0',
  PRIMARY KEY (`year`,`quarter`,`party_id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

DROP TABLE IF EXISTS `maint_overtime_statistics`;

CREATE TABLE `maint_overtime_statistics` (
  `year` VARCHAR(8) COLLATE utf8_bin NOT NULL,
  `quarter` VARCHAR(8) COLLATE utf8_bin NOT NULL,
  `party_id` VARCHAR(8) COLLATE utf8_bin DEFAULT '0',
  `party_name` VARCHAR(64) COLLATE utf8_bin DEFAULT '0',
  `overtime_num` VARCHAR(8) COLLATE utf8_bin DEFAULT '0',
  PRIMARY KEY (`year`,`quarter`,`party_id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

BEGIN;
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','机房、滑轮间环境 ','清洁，门窗完好，照明正常','roomEnvironment');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','手动紧急操作装置 ','齐全，在指定位置','emergencyOperationDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','驱动主机 ','运行时无异常振动和异常声','driveHost');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','制动器各销轴部位 ','动作灵活','brakeEachPosition');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','制动器间隙 ','打开时制动衬与制动轮不应值符合制造单位要求','brakeClearance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','制动器作为轿厢意外移动保护装置制停子系统时的自监测','制动力人工方式检测符合使求；制动力自监测系统有记','breakExternalProtection');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','编码器 ','清洁，安装牢固','encoder');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','限速器各销轴部位 ','润滑，转动灵活；电气开关','limiterEachPart');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','层门和轿门旁路装置 ','工作正常','bypassDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','紧急电动运行 ','工作正常','emergencyElectricOperation');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿顶 ','清洁，防护栏安全可靠','carTop');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿顶检修开关、停止装置 ','工作正常','carTopSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','导靴上油杯 ','吸油毛毡齐全，油量适宜，','guideShoeCup');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','对重/平衡重块及其压板 ','对重/平衡重块无松动，压板','counterweightBlock');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','井道照明 ','齐全，正常','wellIllumination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿厢照明、风扇、应急照明 ','工作正常','carLighting');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿厢检修开关、停止装置 ','工作正常','carOverhaulSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿内报警装置、对讲系统 ','工作正常','carAlarmDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿内显示、指令按钮、 IC 卡系统 ','齐全，有效','displayCommandButton');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿门防撞击保护装置(安全触板，光幕、光电等) ','功能有效','antiCollisionProtector');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿门门锁电气触点 ','清洁，触点接触良好，接线','electricContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿门运行 ','开启和关闭工作正常','carDoorRun');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','轿厢平层准确度 ','符合标准值','accuracyCarDeck');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','层站召唤、层楼显示 ','齐全，有效','stationCall');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','层门地坎 ','清洁','landingSill');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','层门自动关门装置 ','正常','automaticClosingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','层门门锁自动复位 ','用层门钥匙打开手动开锁装置释放后，层门门锁能自动复位','automaticReset');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','层门门锁电气触点 ','清洁，触点接触良好，接线可靠','electricalContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','层门锁紧元件啮合长度 ','不小于 7mm','layerLockingLength');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','底坑环境 ','清洁，无渗水、积水，照明正常','pitEenvironment');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','1','底坑停止装置 ','工作正常','pitStop');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','减速机润滑油 ','油量适宜，除蜗杆伸出端外均无渗漏','lubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','制动衬 ','清洁，磨损量不超过制造单位要求','brakeLining');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','编码器 ','工作正常','encoder');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','选层器动静触点 ','清洁，无烧蚀','layerDynamicContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','曳引轮槽、悬挂装置 ','清洁，钢丝绳无严重油腻，张力均匀，符合制造单位要求','tractionWheelGroove');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','限速器轮槽、限速器钢丝绳 ','清洁，无严重油腻','limiterWheelWire');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','靴衬、滚轮 ','清洁，磨损量不超过制造单位要求','carShoeRoller');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','验证轿门关闭的电气安全装置 ','工作正常','electricalSafetyDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','层门、轿门系统中传动钢丝绳、链条、传动带 ','按照制造单位要求进行清洁、调整','transmissionSteel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','层门门导靴 ','磨损量不超过制造单位要求','doorGuideShoe');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','消防开关 ','工作正常，功能有效','fireSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','耗能缓冲器 ','电气安全装置功能有效，油量适宜，柱塞无锈蚀','energyDissipationBuffer');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','2','限速器张紧轮装置和电气安全装置 ','工作正常','limiterWheelSafety');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','电动机与减速机联轴器 ','连接无松动，弹性元件外观良好，无老化等现象','motorReducerCoupling');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','驱动轮、导向轮轴承部 ','无异常声响，无振动，润滑良好','drivingWheel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','曳引轮槽 ','磨损量不超过制造单位要求','tractionWheelGroove');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','制动器动作状态监测装置 ','工作正常，制动器动作可靠','brakeActionMonitoring');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','控制柜内各接线端子 ','各接线紧固、整齐，线号齐全清晰','controlCabinetTerminals');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','控制柜各仪表 ','显示正常','allInstrument');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','井道、对重、轿顶各反绳轮轴承部 ','无异常声响，无振动，润滑良好','bearingDepartment');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','悬挂装置、补偿绳 ','磨损量、断丝数不超过要求','compensatingRope');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','绳头组合 ','螺母无松动','ropeCombination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','限速器钢丝绳 ','磨损量、断丝数不超过制造单位要求','limiterWireRope');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','层门、轿门门扇 ','门扇各相关间隙符合标准值','limiterWheelWire');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','轿门开门限制装置 ','工作正常','doorOpenLimitDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','对重缓冲距离 ','符合标准值','bufferDistance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','补偿链(绳)与轿厢、对重接合处 ','固定，无松动','compensationLink');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','3','上、下极限开关 ','工作正常','limitSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','减速机润滑油 ','按照制造单位要求适时更换，保证油质符合要求','yearLubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','控制柜接触器、继电器触点 ','接触良好','contactorContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','制动器铁芯(柱塞) ','进行清洁、润滑、检查，磨损量不超过制造单位要求','brakePlunger');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','制动器制动能力','符合制造单位要求，保持有足够的制动力，必要时进行轿厢装载 125%额定载重量的制动试验','brakeCapacity');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','导电回路绝缘性能测试 ','符合标准','insulationPerformanceTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','限速器安全钳联动试验(对于使用年限不超过 15 年的限速器，每2 年进行一次限速器动作速度校验；对于使用年限超过 15 年的限速器，每年进行一次限速器动作速度校验)','工作正常','limiterSafetyClampLinkageTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','上行超速保护装置动作试验 ','工作正常','uplinkOverspeedProtectionTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','轿厢意外移动保护装置动作试验 ','工作正常','carEmergencyTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','轿顶、轿厢架、轿门及其附件安装螺栓 ','紧固','topMountingBolt');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','轿厢和对重/平衡重的导轨支架 ','固定，无松动','carGuideBracket');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','轿厢和对重/平衡重的导轨 ','清洁，压板牢固','carGuideRail');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','随行电缆 ','无损伤','travelingCable');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','层门装置和地坎 ','无影响正常使用的变形，各安装螺栓紧固','deviceAndSill');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','轿厢称重装置 ','准确有效','carWeighingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','安全钳钳座 ','固定，无松动','safetyClampHolder');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','轿底各安装螺栓 ','紧固','bottomMountingBolt');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('1','4','缓冲器 ','固定，无松动','buffer');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','机房环境 ','清洁，室温符合要求，门窗完好','roomEnvironment');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','机房内手动泵操作装置 ','齐全，在指定位置','operatingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','油箱 ','油量、油温正常，无杂质、无漏','tank');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','电动机 ','运行时无异常振动和异常声响','motor');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','层门和轿门旁路装置 ','工作正常','gateBypassDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','阀、泵、消音器、油管、表、接口等部件 ','无漏油现象','sthParts');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','编码器 ','清洁，安装牢固','encoder');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿顶 ','清洁，防护栏安全可靠','carTop');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿顶检修开关、停止装置 ','工作正常','cartopOverhaulDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','导靴上油杯 ','吸油毛毡齐全，油量适宜，油杯','guideShoeCup');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','井道照明 ','齐全，正常','wellIllumination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','限速器各销轴部位 ','润滑，转动灵活，电气开关正常','limiterEachPart');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿厢照明、风扇、应急照明 ','工作正常','carLighting');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿厢检修开关、停止装置 ','工作正常','carOverhaulSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿内报警装置、对讲系统 ','正常','alarmIntercom');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿内显示、指令按钮 ','齐全，有效','displayCommandButton');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿门防撞击保护装置(安全触板，光幕、光电等) ','功能有效','antiCollisionProtector');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿门门锁触点 ','清洁，触点接触良好，接线可靠','cardoorLockContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿门运行 ','开启和关闭工作正常','carDoorRun');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','轿厢平层准确度 ','符合标准值','carDeckAccuracy');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','层站召唤、层楼显示 ','齐全，有效','storeyDisplay');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','层门地坎 ','清洁','landingSill');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','层门自动关门装置 ','正常','automaticClosingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','层门门锁自动复位 ','用层门钥匙打开手动开锁装置释放后，层门门锁能自动复位','automaticReset');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','层门门锁电气触点 ','清洁，触点接触良好，接线可靠','electricalContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','层门锁紧元件啮合长度 ','不小于 7mm','layerLockingLength');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','底坑 ','清洁，无渗水、积水，照明正常','pit');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','底坑停止装置 ','工作正常','pitStop');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','液压柱塞 ','无漏油，运行顺畅，柱塞表面光滑','hydraulicPlunger');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','1','井道内液压油管、接口 ','无漏油','hydraulicOilPipe');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','安全溢流阀(在油泵与单向阀之间) ','其工作压力不得高于满负荷压力的 170%','safetyReliefValve');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','手动下降阀','通过下降阀动作，轿厢能下降；系统压力小于该阀最小操作压力时，手动操作应无效(间接式液压电梯)','handDownValve');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','手动泵 ','通过手动泵动作，轿厢被提升；相连接的溢流阀工作压力不得高于满负荷压力的 2.3 倍','handPump');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','油温监控装置 ','功能可靠','oilTemperatureMonitor');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','限速器轮槽、限速器钢丝绳 ','清洁，无严重油腻','limiterWheelWire');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','验证轿门关闭的电气安全装置 ','工作正常','electricalSafetyDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','轿厢侧靴衬、滚轮 ','磨损量不超过制造单位要求','carShoeRoller');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','柱塞侧靴衬 ','清洁，磨损量不超过制造单位要求','plungerSideShoe');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','层门、轿门系统中传动钢丝绳、链条、胶带 ','按照制造单位要求进行清洁、调整','transmissionWireRope');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','层门门导靴 ','磨损量不超过制造单位要求','doorGuideShoe');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','消防开关 ','工作正常，功能有效','fireSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','耗能缓冲器 ','电气安全装置功能有效，油量适宜，柱塞无锈蚀','energyDissipationBuffer');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','2','限速器张紧轮装置和电气安全装置 ','工作正常','limiterTensioningWheel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','3','控制柜内各接线端子 ','各接线紧固，整齐，线','controlCabinetTerminals');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','3','控制柜 ','各仪表显示正确','controlCabinet');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','3','导向轮 ','轴承部无异常声响','guideWheel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','3','悬挂钢丝绳 ','磨损量、断丝数未超过','suspensionWireRope');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','3','悬挂钢丝绳绳头组合 ','螺母无松动','wireHeadCombination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','3','限速器钢丝绳 ','磨损量、断丝数不超过','limiterWireRope');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','3','柱塞限位装置 ','符合要求','plungerSpacingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','3','上下极限开关 ','工作正常','updownLimitSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','3','柱塞、消音器放气操作 ','符合要求','bleedOperation');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','轿厢及油缸导轨 ','清洁，压板牢固','carCylinderGuide');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','轿底各安装螺栓 ','紧固','mountingBolts');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','缓冲器 ','固定，无松动','buffer');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','轿厢沉降试验 ','符合标准值','carSubsidenceTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','控制柜接触器、继电器触点 ','接触良好','relayContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','动力装置各安装螺栓 ','紧固','powerMountingBolts');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','导电回路绝缘性能测试 ','符合标准值','insulationPerformanceTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','限速器安全钳联动试验(每 2 年进行一次限速器动作速度校验) ','工作正常','limiterSafetyclampTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','随行电缆 ','无损伤','travelingCable');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','层门装置和地坎 ','无影响正常使用的变形','storeyGateDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','轿顶、轿厢架、轿门及附件安装螺栓 ','紧固','mountingBolt');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','轿厢称重装置 ','准确有效','carWeighingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','安全钳钳座 ','固定，无松动','safetyClampHolder');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('2','4','轿厢及油缸导轨支架 ','牢固','guideBracket');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','机房、通道环境 ','清洁，门窗完好，照明正常','cproomEnvironment');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','手动紧急操作装置 ','齐全，在指定位置','manualEmergencyOperation');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','驱动主机 ','运行时无异常振动和异常声响','driveHost');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','制动器各销轴部位 ','润滑，动作灵活','brakePosition');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','制动器间隙 ','打开时制动衬与制动轮不发生摩擦','brakeClearance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','限速器各销轴部位 ','润滑，转动灵活，电气开关正常','limiterPart');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','轿顶 ','清洁','carTop');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','轿顶停止装置 ','工作正常','stopDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','导靴上油杯 ','吸油毛毡齐全，油量适宜，油杯无泄漏','oilCup');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','对重/平衡重块及压板 ','对重/平衡重块无松动，压板紧固','counterWeight');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','井道照明 ','齐全，正常','wellLight');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','轿门门锁触点 ','清洁，触点接触良好，接线可靠','doorLockContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','层站召唤、层楼显示 ','齐全，有效','floorDisplay');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','层门地坎 ','清洁','landingSill');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','层门门锁自动复位 ','用层门钥匙打开手动开锁装置释放后，门锁能自动复位','doorAutoReset');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','层门门锁电气触点 ','清洁，触点接触良好，接线可靠','electricalContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','层门锁紧元件啮合长度 ','不小于 5mm','lockingLength');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','层门门导靴 ','无卡阻，滑动顺畅','doorGuide');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','底坑环境 ','清洁，无渗水、积水，照明正常','pitEnvironment');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','1','底坑停止装置 ','工作正常','pitStop');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','2','减速机润滑油 ','油量适宜，除蜗杆伸出','lubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','2','制动衬 ','清洁，磨损量不超制造','brakeLining');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','2','曳引轮槽、悬挂装置 ','清洁，无严重油腻，张','tractionWheelGroove');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','2','限速器轮槽、限速器钢丝绳 ','清洁，无严重油腻','limiterWheelGroove');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','2','靴衬 ','清洁，磨损量不超过制','shoeLinin');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','2','层门、轿门系统中传动钢丝绳、链条、传动带 ','按照制造单位要求进行','transmissionSteel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','2','层门门导靴 ','磨损量不超过制造单位','doorGuideShoe');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','2','限速器张紧轮装置和电气安全装置 ','工作正常','limiterWheelSafety');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','电动机与减速机联轴器 ','连接无松动，弹性元件现象','motorCoupling');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','驱动轮、导向轮轴承部 ','无异常声响，无振动，','drivingWheel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','制动器上检测开关 ','工作正常，制动器动作','testSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','控制柜内各接线端子 ','各接线紧固、整齐，线','lineTerminals');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','控制柜各仪表 ','显示正确','allInstrument');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','悬挂装置 ','磨损量、断丝数未超过','suspensionDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','绳头组合 ','螺母无松动','ropeCombination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','限速器钢丝绳 ','磨损量、断丝数不超过','limiterWireRope');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','对重缓冲距离 ','符合标准值','bufferDistance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','3','上、下极限开关 ','工作正常','limitSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','减速机润滑油 ','按照制造单位要求适时更换，油质符合要求','yearLubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','控制柜接触器、继电器触点 ','接触良好','contactorContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','制动器铁芯(柱塞) ','分解进行清洁、润滑、检查，磨损量不超过制造单位要求','brakePlunger');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','制动器制动弹簧压缩量 ','符合制造单位要求，保持有足够的制动力','brakeSpringCompression');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','导电回路绝缘性能测试 ','符合标准值','insulationPerformanceTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','限速器安全钳联动试验(每 5 年进行一次限速器动作速度校验) ','工作正常','limiterSafetyClampLinkageTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','轿顶、轿厢架、轿门及附件安装螺栓 ','紧固','topMountingBolt');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','轿厢及对重/平衡重导轨支架 ','固定，无松动','railBracket');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','轿厢及对重/平衡重导轨 ','清洁，压板牢固','guide');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','随行电缆 ','无损伤','travelingCable');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','层门装置和地坎 ','无影响正常使用的变形，各安装螺栓紧固','deviceAndSill');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','安全钳钳座 ','固定，无松动','safetyClampHolder');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','轿底各安装螺栓 ','紧固','bottomMountingBolt');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('3','4','缓冲器 ','固定，无松动','buffer');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','电器部件 ','清洁，接线紧固','electricalComponents');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','故障显示板 ','信号功能正常','faultDisplayBoard');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','设备运行状况 ','正常，没有异常声响和抖动','equipmentOperationStatus');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','主驱动链 ','运转正常，电气安全保护装置动作有效','hmonmainDriveChain');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','制动器机械装置 ','清洁，动作正常','hmonBrakeMechanism');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','制动器状态监测开关 ','工作正常','brakeConditionMonitoringSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','减速机润滑油 ','油量适宜，无渗油','hmonReducerLubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','电机通风口 ','清洁','motorVent');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','检修控制装置 ','工作正常','inspectionControlDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','自动润滑油罐油位 ','油位正常，润滑系统工作正常','automaticOilLevel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','梳齿板开关 ','工作正常','combPlateSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','梳齿板照明 ','照明正常','combPlateIllumination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','梳齿板梳齿与踏板面齿槽、导向胶带','梳齿板完好无损，梳齿板梳齿与踏板面齿槽、导向胶带啮合正常','combTreadTooth');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','梯级或者踏板下陷开关 ','工作正常','pedalSinkSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','梯级或者踏板缺失监测装置 ','工作正常','pedalMissingMonitoring');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','超速或非操纵逆转监测装置 ','工作正常','overspeedMonitoringDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','检修盖板和楼层板 ','防倾覆或者翻转措施和监控装置有效、可靠','repairCoverPlate');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','梯级链张紧开关 ','位置正确，动作正常','stepchainTensionSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','防护挡板 ','有效，无破损','protectiveBaffle');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','梯级滚轮和梯级导轨 ','工作正常','stepRollerGuiderail');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','梯级、踏板与围裙板之间的间隙 ','任何一侧的水平间隙及两侧间隙之和符合标准值','pedalApronClearance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','运行方向显示 ','工作正常','runningDirectionDisplay');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','扶手带入口处保护开关 ','动作灵活可靠，清除入口处垃圾','protectiveSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','扶手带 ','表面无毛刺，无机械损伤，运行无摩擦','handrail');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','扶手带运行 ','速度正常','handrailRun');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','扶手护壁板 ','牢固可靠','handrailBaseboard');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','上下出入口处的照明 ','工作正常','updownIllumination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','上下出入口和扶梯之间保护栏杆 ','牢固可靠','updownProtectRailing');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','出入口安全警示标志 ','齐全，醒目','exitSafetyWarn');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','分离机房、各驱动和转向站 ','清洁，无杂物','separateroomDriveSteeringstation');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','自动运行功能 ','工作正常','autoRunFunction');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','紧急停止开关 ','工作正常','emergencyStopSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','1','驱动主机的固定 ','牢固可靠','fixingOfMain');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','2','扶手带的运行速度 ','相对于梯级、踏板或者胶带的速度允差为 0～＋2％','speedOfHandrail');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','2','梯级链张紧装置 ','工作正常','stepchainTensioningDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','2','梯级轴衬 ','润滑有效','stepBushings');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','2','梯级链润滑 ','运行工况正常','cascadeLubrication');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','2','防灌水保护装置 ','动作可靠(雨季到来之前必须完成)','antifloodProtectionDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','制动衬厚度 ','不小于制造单位要求','brakeLiningThickness');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','主驱动链 ','清理表面油污，润滑','hyearMainDriveChain');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','主驱动链链条滑块 ','清洁，厚度符合制造单位要求','maindriveSlider');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','电动机与减速机联轴器 ','连接无松动，弹性元件外观良好，无老化等现象','motorReducerCoupling');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','空载向下运行制动距离 ','符合标准值','noloadRunDistance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','制动器机械装置 ','润滑，工作有效','hyearBrakeMechanism');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','附加制动器 ','清洁和润滑，功能可靠','auxiliaryBrake');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','减速机润滑油 ','按照制造单位的要求进行检查、更换','hyearReducerLubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','调整梳齿板梳齿与踏板面齿槽啮合深度和间隙 ','符合标准值','adjustDepthClearance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','扶手带张紧度张紧弹簧负荷长度 ','符合制造单位要求','armrestSpringLength');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','扶手带速度监控系统 ','工作正常','handrailSpeedMonitoring');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','3','梯级踏板加热装置 ','功能正常，温度感应器接线牢固(冬季到来之前必须完成)','steppedalHeatingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','主接触器 ','工作可靠','mainContactor');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','主机速度检测功能 ','功能可靠，清洁感应面、感应间隙符合制造单位要求','hostSpeedDetection');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','电缆 ','无破损，固定牢固','cable');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','扶手带托轮、滑轮群、防静电轮 ','清洁，无损伤，托轮转动平滑','handrailWheel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','扶手带内侧凸缘处 ','无损伤，清洁扶手导轨滑动面','armrestInnerFlange');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','扶手带断带保护开关 ','功能正常','handrailBreakingProtective');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','扶手带导向块和导向轮 ','清洁，工作正常','HandrailGuideblockGuidewheel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','进入梳齿板处的梯级与导轮的轴向窜动量 ','符合制造单位要求','innerMomentum');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','内外盖板连接 ','紧密牢固，连接处的凸台、缝隙符合制造单位要求','inoutPlateConnection');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','围裙板安全开关 ','测试有效','apronplateSafetySwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','围裙板对接处 ','紧密平滑','apronplateButtJoint');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('4','4','电气安全装置 ','动作可靠','electricalSafetyDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','机房、滑轮间环境 ','清洁，门窗完好，照明正常','roomEnvironment');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','手动紧急操作装置 ','齐全，在指定位置','emergencyOperationDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','驱动主机 ','运行时无异常振动和异常声','driveHost');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','制动器各销轴部位 ','动作灵活','brakeEachPosition');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','制动器间隙 ','打开时制动衬与制动轮不应值符合制造单位要求','brakeClearance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','制动器作为轿厢意外移动保护装置制停子系统时的自监测','制动力人工方式检测符合使求；制动力自监测系统有记','breakExternalProtection');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','编码器 ','清洁，安装牢固','encoder');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','限速器各销轴部位 ','润滑，转动灵活；电气开关','limiterEachPart');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','层门和轿门旁路装置 ','工作正常','bypassDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','紧急电动运行 ','工作正常','emergencyElectricOperation');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿顶 ','清洁，防护栏安全可靠','carTop');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿顶检修开关、停止装置 ','工作正常','carTopSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','导靴上油杯 ','吸油毛毡齐全，油量适宜，','guideShoeCup');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','对重/平衡重块及其压板 ','对重/平衡重块无松动，压板','counterweightBlock');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','井道照明 ','齐全，正常','wellIllumination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿厢照明、风扇、应急照明 ','工作正常','carLighting');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿厢检修开关、停止装置 ','工作正常','carOverhaulSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿内报警装置、对讲系统 ','工作正常','carAlarmDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿内显示、指令按钮、 IC 卡系统 ','齐全，有效','displayCommandButton');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿门防撞击保护装置(安全触板，光幕、光电等) ','功能有效','antiCollisionProtector');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿门门锁电气触点 ','清洁，触点接触良好，接线','electricContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿门运行 ','开启和关闭工作正常','carDoorRun');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','轿厢平层准确度 ','符合标准值','accuracyCarDeck');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','层站召唤、层楼显示 ','齐全，有效','stationCall');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','层门地坎 ','清洁','landingSill');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','层门自动关门装置 ','正常','automaticClosingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','层门门锁自动复位 ','用层门钥匙打开手动开锁装置释放后，层门门锁能自动复位','automaticReset');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','层门门锁电气触点 ','清洁，触点接触良好，接线可靠','electricalContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','层门锁紧元件啮合长度 ','不小于 7mm','layerLockingLength');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','底坑环境 ','清洁，无渗水、积水，照明正常','pitEenvironment');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','1','底坑停止装置 ','工作正常','pitStop');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','减速机润滑油 ','油量适宜，除蜗杆伸出端外均无渗漏','lubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','制动衬 ','清洁，磨损量不超过制造单位要求','brakeLining');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','编码器 ','工作正常','encoder');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','选层器动静触点 ','清洁，无烧蚀','layerDynamicContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','曳引轮槽、悬挂装置 ','清洁，钢丝绳无严重油腻，张力均匀，符合制造单位要求','tractionWheelGroove');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','限速器轮槽、限速器钢丝绳 ','清洁，无严重油腻','limiterWheelWire');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','靴衬、滚轮 ','清洁，磨损量不超过制造单位要求','carShoeRoller');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','验证轿门关闭的电气安全装置 ','工作正常','electricalSafetyDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','层门、轿门系统中传动钢丝绳、链条、传动带 ','按照制造单位要求进行清洁、调整','transmissionSteel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','层门门导靴 ','磨损量不超过制造单位要求','doorGuideShoe');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','消防开关 ','工作正常，功能有效','fireSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','耗能缓冲器 ','电气安全装置功能有效，油量适宜，柱塞无锈蚀','energyDissipationBuffer');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','2','限速器张紧轮装置和电气安全装置 ','工作正常','limiterWheelSafety');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','电动机与减速机联轴器 ','连接无松动，弹性元件外观良好，无老化等现象','motorReducerCoupling');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','驱动轮、导向轮轴承部 ','无异常声响，无振动，润滑良好','drivingWheel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','曳引轮槽 ','磨损量不超过制造单位要求','tractionWheelGroove');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','制动器动作状态监测装置 ','工作正常，制动器动作可靠','brakeActionMonitoring');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','控制柜内各接线端子 ','各接线紧固、整齐，线号齐全清晰','controlCabinetTerminals');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','控制柜各仪表 ','显示正常','allInstrument');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','井道、对重、轿顶各反绳轮轴承部 ','无异常声响，无振动，润滑良好','bearingDepartment');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','悬挂装置、补偿绳 ','磨损量、断丝数不超过要求','compensatingRope');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','绳头组合 ','螺母无松动','ropeCombination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','限速器钢丝绳 ','磨损量、断丝数不超过制造单位要求','limiterWireRope');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','层门、轿门门扇 ','门扇各相关间隙符合标准值','limiterWheelWire');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','轿门开门限制装置 ','工作正常','doorOpenLimitDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','对重缓冲距离 ','符合标准值','bufferDistance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','补偿链(绳)与轿厢、对重接合处 ','固定，无松动','compensationLink');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','3','上、下极限开关 ','工作正常','limitSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','减速机润滑油 ','按照制造单位要求适时更换，保证油质符合要求','yearLubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','控制柜接触器、继电器触点 ','接触良好','contactorContact');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','制动器铁芯(柱塞) ','进行清洁、润滑、检查，磨损量不超过制造单位要求','brakePlunger');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','制动器制动能力','符合制造单位要求，保持有足够的制动力，必要时进行轿厢装载 125%额定载重量的制动试验','brakeCapacity');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','导电回路绝缘性能测试 ','符合标准','insulationPerformanceTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','限速器安全钳联动试验(对于使用年限不超过 15 年的限速器，每2 年进行一次限速器动作速度校验；对于使用年限超过 15 年的限速器，每年进行一次限速器动作速度校验)','工作正常','limiterSafetyClampLinkageTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','上行超速保护装置动作试验 ','工作正常','uplinkOverspeedProtectionTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','轿厢意外移动保护装置动作试验 ','工作正常','carEmergencyTest');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','轿顶、轿厢架、轿门及其附件安装螺栓 ','紧固','topMountingBolt');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','轿厢和对重/平衡重的导轨支架 ','固定，无松动','carGuideBracket');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','轿厢和对重/平衡重的导轨 ','清洁，压板牢固','carGuideRail');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','随行电缆 ','无损伤','travelingCable');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','层门装置和地坎 ','无影响正常使用的变形，各安装螺栓紧固','deviceAndSill');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','轿厢称重装置 ','准确有效','carWeighingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','安全钳钳座 ','固定，无松动','safetyClampHolder');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','轿底各安装螺栓 ','紧固','bottomMountingBolt');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('5','4','缓冲器 ','固定，无松动','buffer');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','电器部件 ','清洁，接线紧固','electricalComponents');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','故障显示板 ','信号功能正常','faultDisplayBoard');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','设备运行状况 ','正常，没有异常声响和抖动','equipmentOperationStatus');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','主驱动链 ','运转正常，电气安全保护装置动作有效','hmonmainDriveChain');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','制动器机械装置 ','清洁，动作正常','hmonBrakeMechanism');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','制动器状态监测开关 ','工作正常','brakeConditionMonitoringSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','减速机润滑油 ','油量适宜，无渗油','hmonReducerLubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','电机通风口 ','清洁','motorVent');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','检修控制装置 ','工作正常','inspectionControlDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','自动润滑油罐油位 ','油位正常，润滑系统工作正常','automaticOilLevel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','梳齿板开关 ','工作正常','combPlateSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','梳齿板照明 ','照明正常','combPlateIllumination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','梳齿板梳齿与踏板面齿槽、导向胶带','梳齿板完好无损，梳齿板梳齿与踏板面齿槽、导向胶带啮合正常','combTreadTooth');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','梯级或者踏板下陷开关 ','工作正常','pedalSinkSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','梯级或者踏板缺失监测装置 ','工作正常','pedalMissingMonitoring');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','超速或非操纵逆转监测装置 ','工作正常','overspeedMonitoringDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','检修盖板和楼层板 ','防倾覆或者翻转措施和监控装置有效、可靠','repairCoverPlate');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','梯级链张紧开关 ','位置正确，动作正常','stepchainTensionSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','防护挡板 ','有效，无破损','protectiveBaffle');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','梯级滚轮和梯级导轨 ','工作正常','stepRollerGuiderail');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','梯级、踏板与围裙板之间的间隙 ','任何一侧的水平间隙及两侧间隙之和符合标准值','pedalApronClearance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','运行方向显示 ','工作正常','runningDirectionDisplay');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','扶手带入口处保护开关 ','动作灵活可靠，清除入口处垃圾','protectiveSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','扶手带 ','表面无毛刺，无机械损伤，运行无摩擦','handrail');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','扶手带运行 ','速度正常','handrailRun');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','扶手护壁板 ','牢固可靠','handrailBaseboard');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','上下出入口处的照明 ','工作正常','updownIllumination');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','上下出入口和扶梯之间保护栏杆 ','牢固可靠','updownProtectRailing');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','出入口安全警示标志 ','齐全，醒目','exitSafetyWarn');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','分离机房、各驱动和转向站 ','清洁，无杂物','separateroomDriveSteeringstation');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','自动运行功能 ','工作正常','autoRunFunction');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','紧急停止开关 ','工作正常','emergencyStopSwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','1','驱动主机的固定 ','牢固可靠','fixingOfMain');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','2','扶手带的运行速度 ','相对于梯级、踏板或者胶带的速度允差为 0～＋2％','speedOfHandrail');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','2','梯级链张紧装置 ','工作正常','stepchainTensioningDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','2','梯级轴衬 ','润滑有效','stepBushings');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','2','梯级链润滑 ','运行工况正常','cascadeLubrication');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','2','防灌水保护装置 ','动作可靠(雨季到来之前必须完成)','antifloodProtectionDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','制动衬厚度 ','不小于制造单位要求','brakeLiningThickness');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','主驱动链 ','清理表面油污，润滑','hyearMainDriveChain');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','主驱动链链条滑块 ','清洁，厚度符合制造单位要求','maindriveSlider');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','电动机与减速机联轴器 ','连接无松动，弹性元件外观良好，无老化等现象','motorReducerCoupling');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','空载向下运行制动距离 ','符合标准值','noloadRunDistance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','制动器机械装置 ','润滑，工作有效','hyearBrakeMechanism');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','附加制动器 ','清洁和润滑，功能可靠','auxiliaryBrake');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','减速机润滑油 ','按照制造单位的要求进行检查、更换','hyearReducerLubricatingOil');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','调整梳齿板梳齿与踏板面齿槽啮合深度和间隙 ','符合标准值','adjustDepthClearance');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','扶手带张紧度张紧弹簧负荷长度 ','符合制造单位要求','armrestSpringLength');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','扶手带速度监控系统 ','工作正常','handrailSpeedMonitoring');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','3','梯级踏板加热装置 ','功能正常，温度感应器接线牢固(冬季到来之前必须完成)','steppedalHeatingDevice');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','主接触器 ','工作可靠','mainContactor');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','主机速度检测功能 ','功能可靠，清洁感应面、感应间隙符合制造单位要求','hostSpeedDetection');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','电缆 ','无破损，固定牢固','cable');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','扶手带托轮、滑轮群、防静电轮 ','清洁，无损伤，托轮转动平滑','handrailWheel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','扶手带内侧凸缘处 ','无损伤，清洁扶手导轨滑动面','armrestInnerFlange');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','扶手带断带保护开关 ','功能正常','handrailBreakingProtective');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','扶手带导向块和导向轮 ','清洁，工作正常','HandrailGuideblockGuidewheel');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','进入梳齿板处的梯级与导轮的轴向窜动量 ','符合制造单位要求','innerMomentum');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','内外盖板连接 ','紧密牢固，连接处的凸台、缝隙符合制造单位要求','inoutPlateConnection');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','围裙板安全开关 ','测试有效','apronplateSafetySwitch');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','围裙板对接处 ','紧密平滑','apronplateButtJoint');
INSERT INTO maint_fields (ELEVATOR_TYPE,MAINT_TYPE,ITEM,DEMAND,EN_ITEM) values ('6','4','电气安全装置 ','动作可靠','electricalSafetyDevice');

INSERT INTO `party_role_type` VALUES ('1', '5', '1'), ('2', '1', '1'), ('3', '2', '1'), ('4', '3', '1'), ('5', '4', '1'), ('6', '4', '2'), ('7', '2', '3'), ('8', '1', '3'), ('9', '3', '3'), ('10', '1', '4'), ('11', '2', '4'), ('12', '3', '4'), ('13', '4', '4'), ('14', '1', '5'), ('15', '2', '5'), ('16', '3', '5'), ('17', '4', '5');
INSERT INTO `system_role_type` VALUES ('1', null, '系统管理员'), ('2', null, '特种设备安全监察人员'), ('3', null, '特种设备作业人员'), ('4', null, '特种设备安全管理人员'), ('5', null, '办公人员');
INSERT INTO `system_role` VALUES ('1', '超级管理员', '超级管理员'), ('3', '安全监察员', '安全监察员'), ('4', '安全监察协管员', '安全监察协管员'), ('5', '电梯安全管理员', '电梯安全管理员'), ('6', '电梯司机', '电梯司机'), ('7', '电梯维保人员', '电梯维保人员'), ('8', '电梯检验员/师', '电梯检验员/师'), ('10', '监管办公人员', '监管办公人员'), ('11', '企业办公人员', '企业办公人员'), ('12', '监管部门的系统管理员', '监管系统管理员'), ('13', '物业系统管理员', '物业系统管理员'), ('14', '维保系统管理员', '维保系统管理员'), ('15', '检验系统管理员', '检验系统管理员'), ('16', '物业管理人员', '物业管理人员'), ('17', '维保管理人员', '维保管理人员'), ('18', '监管管理人员', '监管管理人员'), ('19', '检验管理人员', '检验管理人员');
INSERT INTO `system_author` (id,author_describe,author_name,author_url,parent_id,author_icon,sys_type,author_id,author_type) VALUES ('1', '系统管理', '系统管理', '', '0', 'desktop', 'pc', 'AID00001', 'menu'), ('2', '本机构员工账号、档案管理', '用户管理', '/home/user', '1', 'team', 'pc', 'AID00005', 'menu'), ('3', '角色的管理', '角色管理', '/home/role', '1', 'tag', 'pc', 'AID00006', 'menu'), ('4', '系统功能的管理', '菜单管理', '/home/function', '1', 'bars', 'pc', 'AID00007', 'menu'), ('5', '机构管理', '机构管理', '/home/party', '1', 'fork', 'pc', 'AID00008', 'menu'), ('6', '电梯管理', '电梯管理', '/home/elevator', '0', 'hdd', 'pc', 'AID000010', 'menu'), ('7', '电梯台账信息', '电梯台账', '/home/elevator', '6', 'info-circle-o', 'pc', 'AID00009', 'menu'), ('8', '资讯管理', '资讯管理', '/home/information', '1', 'mail', 'pc', 'AID000011', 'menu'), ('9', '企业资料', '企业资料', '/home/partyDetails', '1', 'paper-clip', 'pc', 'AID000012', 'menu'), ('10', '消息通知', '消息通知', '/home/notice', '1', 'notification', 'pc', 'AID000013', 'menu'), ('11', '乘客的评价', '乘客评价', '/home/complaintHis', '6', 'file-text', 'pc', 'AID000014', 'menu'), ('13', '救援演练', '救援演练', '/home/rescueDrill', '6', 'video-camera', 'pc', 'AID000016', 'menu'), ('14', '用户新增', '用户新增', null, '2', null, 'pc', 'SID00001', 'func'), ('15', '用户修改', '用户修改', null, '2', null, 'pc', 'SID00002', 'func'), ('16', '用户删除', '用户删除', null, '2', null, 'pc', 'SID00003', 'func'), ('17', '角色新增', '角色新增', null, '3', null, 'pc', 'SID00004', 'func'), ('18', '角色修改', '角色修改', null, '3', null, 'pc', 'SID00005', 'func'), ('19', '角色删除', '角色删除', null, '3', null, 'pc', 'SID00006', 'func'), ('20', '注册审批', '注册审批', '/home/register-check-list', '1', 'file-ppt', 'pc', 'AID000019', 'menu'), ('21', '合同的管理', '合同管理', '/home/contract', '1', 'credit-card', 'pc', 'AID000020', 'menu'), ('22', '广告管理', '广告管理', '/home/advertisement', '1', 'laptop', 'pc', 'AID000021', 'menu'), ('23', '安全监督管理', '安全监督管理', '/home/safeControl', '1', 'schedule', 'pc', 'AID000022', 'menu'), ('24', '机构新增', '机构新增', '', '5', '', 'pc', 'SID00007', 'func'), ('25', '机构修改', '机构修改', '', '5', '', 'pc', 'SID00008', 'func'), ('26', '机构删除', '机构删除', '', '5', '', 'pc', 'SID00009', 'func'), ('27', '资讯添加', '资讯添加', '', '8', '', 'pc', 'SID000010', 'func'), ('28', '资讯详情', '资讯详情', '', '8', '', 'pc', 'SID000011', 'func'), ('29', '资讯删除', '资讯删除', '', '8', '', 'pc', 'SID000012', 'func'), ('30', '资讯修改', '资讯修改', '', '8', '', 'pc', 'SID000013', 'func'), ('31', '电梯添加', '电梯添加', '', '7', '', 'pc', 'SID000014', 'func'), ('32', '电梯修改', '电梯修改', null, '7', null, 'pc', 'SID000015', 'func'), ('34', '电梯安全管理制度', '电梯安全管理制度', '/home/elevator-safe-management', '6', 'credit-card', 'pc', 'AID000023', 'menu'), ('35', '维保上传维保计划', '维保计划', '/home/maintenance-plan', '1', 'inbox', 'pc', 'AID000024', 'menu'), ('36', '合同添加', '合同添加', null, '21', null, 'pc', 'SID000016', 'func'), ('37', '合同删除', '合同删除', null, '21', null, 'pc', 'SID000017', 'func');
INSERT INTO `elevator_type` VALUES ('1', '曳引与强制驱动电梯', '载客电梯'), ('2', '液压驱动电梯', '液压驱动电梯'), ('3', '杂物电梯', '杂物电梯'), ('4', '自动扶梯与自动人行道', '自动扶梯'), ('5', '曳引与强制驱动电梯', '载货电梯'), ('6', '自动扶梯与自动人行道', '自动人行道');
INSERT INTO `system_role_type_relation` VALUES ('1', '1', '1'), ('3', '3', '2'), ('4', '4', '2'), ('5', '5', '3'), ('6', '6', '3'), ('7', '7', '3'), ('8', '8', '3'), ('10', '10', '5'), ('11', '11', '5'), ('12', '12', '1'), ('13', '13', '1'), ('14', '14', '1'), ('15', '15', '1'), ('16', '16', '4'), ('17', '17', '4'), ('18', '18', '4'), ('19', '19', '4');
INSERT INTO `sys_role_author` VALUES ('98', '8', '4'), ('99', '28', '4'), ('100', '10', '4'), ('101', '23', '4'), ('102', '1', '4'), ('103', '1', '3'), ('104', '8', '3'), ('105', '10', '3'), ('106', '23', '3'), ('107', '28', '3'), ('117', '1', '6'), ('118', '8', '6'), ('119', '28', '6'), ('120', '10', '6'), ('121', '6', '6'), ('122', '7', '6'), ('123', '11', '6'), ('124', '13', '6'), ('125', '21', '6'), ('130', '1', '8'), ('131', '8', '8'), ('132', '28', '8'), ('133', '10', '8'), ('167', '1', '9'), ('168', '8', '9'), ('169', '28', '9'), ('170', '10', '9'), ('171', '1', '10'), ('172', '8', '10'), ('173', '28', '10'), ('174', '27', '10'), ('175', '29', '10'), ('176', '30', '10'), ('177', '5', '10'), ('178', '10', '10'), ('179', '23', '10'), ('250', '1', '7'), ('251', '6', '7'), ('252', '7', '7'), ('253', '8', '7'), ('254', '10', '7'), ('255', '11', '7'), ('256', '13', '7'), ('257', '28', '7'), ('258', '1', '1'), ('259', '2', '1'), ('260', '3', '1'), ('261', '4', '1'), ('262', '5', '1'), ('263', '6', '1'), ('264', '7', '1'), ('265', '8', '1'), ('266', '9', '1'), ('267', '10', '1'), ('268', '11', '1'), ('269', '13', '1'), ('270', '14', '1'), ('271', '15', '1'), ('272', '16', '1'), ('273', '17', '1'), ('274', '18', '1'), ('275', '19', '1'), ('276', '20', '1'), ('277', '21', '1'), ('278', '22', '1'), ('279', '23', '1'), ('280', '24', '1'), ('281', '25', '1'), ('282', '26', '1'), ('283', '27', '1'), ('284', '28', '1'), ('285', '29', '1'), ('286', '30', '1'), ('287', '31', '1'), ('288', '32', '1'), ('315', '34', '1'), ('325', '1', '2'), ('326', '2', '2'), ('327', '5', '2'), ('328', '6', '2'), ('329', '7', '2'), ('330', '8', '2'), ('331', '10', '2'), ('332', '11', '2'), ('333', '13', '2'), ('334', '14', '2'), ('335', '15', '2'), ('336', '16', '2'), ('337', '20', '2'), ('338', '21', '2'), ('339', '23', '2'), ('340', '24', '2'), ('341', '25', '2'), ('342', '26', '2'), ('343', '27', '2'), ('344', '28', '2'), ('345', '29', '2'), ('346', '30', '2'), ('347', '31', '2'), ('348', '32', '2'), ('349', '34', '2'), ('431', '1', '15'), ('432', '2', '15'), ('433', '14', '15'), ('434', '15', '15'), ('435', '16', '15'), ('436', '5', '15'), ('437', '8', '15'), ('438', '27', '15'), ('439', '28', '15'), ('440', '29', '15'), ('441', '30', '15'), ('442', '10', '15'), ('443', '20', '15'), ('444', '1', '12'), ('445', '2', '12'), ('446', '5', '12'), ('447', '6', '12'), ('448', '7', '12'), ('449', '8', '12'), ('450', '10', '12'), ('451', '14', '12'), ('452', '15', '12'), ('453', '16', '12'), ('454', '20', '12'), ('455', '23', '12'), ('456', '24', '12'), ('457', '25', '12'), ('458', '26', '12'), ('459', '27', '12'), ('460', '28', '12'), ('461', '29', '12'), ('462', '30', '12'), ('478', '1', '11'), ('479', '6', '11'), ('480', '7', '11'), ('481', '8', '11'), ('482', '10', '11'), ('483', '11', '11'), ('484', '35', '1'), ('485', '1', '14'), ('486', '2', '14'), ('487', '5', '14'), ('488', '6', '14'), ('489', '7', '14'), ('490', '8', '14'), ('491', '10', '14'), ('492', '14', '14'), ('493', '15', '14'), ('494', '16', '14'), ('495', '20', '14'), ('496', '27', '14'), ('497', '28', '14'), ('498', '29', '14'), ('499', '30', '14'), ('500', '35', '14'), ('509', '36', '1'), ('510', '37', '1'), ('511', '1', '13'), ('512', '2', '13'), ('513', '5', '13'), ('514', '6', '13'), ('515', '7', '13'), ('516', '8', '13'), ('517', '10', '13'), ('518', '11', '13'), ('519', '13', '13'), ('520', '14', '13'), ('521', '15', '13'), ('522', '16', '13'), ('523', '20', '13'), ('524', '21', '13'), ('525', '27', '13'), ('526', '28', '13'), ('527', '29', '13'), ('528', '30', '13'), ('529', '31', '13'), ('530', '32', '13'), ('531', '34', '13'), ('532', '36', '13'), ('533', '37', '13'), ('534', '1', '5'), ('535', '6', '5'), ('536', '7', '5'), ('537', '8', '5'), ('538', '11', '5'), ('539', '13', '5'), ('540', '28', '5'), ('541', '34', '5'), ('542', '21', '5'), ('551', '1', '17'), ('552', '2', '17'), ('553', '8', '17'), ('554', '27', '17'), ('555', '28', '17'), ('556', '29', '17'), ('557', '30', '17'), ('558', '10', '17'), ('570', '1', '18'), ('571', '5', '18'), ('572', '8', '18'), ('573', '27', '18'), ('574', '28', '18'), ('575', '29', '18'), ('576', '30', '18'), ('577', '10', '18'), ('578', '6', '18'), ('579', '7', '18'), ('580', '1', '16'), ('581', '6', '16'), ('582', '7', '16'), ('583', '8', '16'), ('584', '10', '16'), ('585', '11', '16'), ('586', '21', '16'), ('587', '28', '16');
INSERT INTO `sys_user` VALUES ('1', null, null, null, null, null, null,  null,'a123456', null, null,  null,'admin', '超级管理员', '1');
INSERT INTO `sys_user_role` VALUES ('1', '1', '1');


INSERT INTO `information_type` VALUES ('1', '行业资讯', '行业资讯'), ('2', '法律法规', '法律法规'), ('3', '工作资讯', '工作资讯');

INSERT INTO `info_attachment`
VALUES
  (
    '1',
    '国务院关于加强质量认证体系建设',
    '1',
    '4',
    '行业资讯',
    '23.docx'
  ),
  (
    '2',
    '国务院办公厅关于加强电梯质量安全工作的意见',
    '1',
    '4',
    '行业资讯',
    '24.doc'
  ),
  (
    '3',
    '中华人民共和国特种设备安全法',
    '2',
    '4',
    '法律法规',
    '25.doc'
  ),
  (
    '4',
    '特种设备安全监察条例',
    '2',
    '4',
    '法律法规',
    '26.docx'
  ),
  (
    '5',
    '特种设备现场安全监督检查规则',
    '2',
    '4',
    '法律法规',
    '27.doc'
  ),
  (
    '6',
    '国务院关于加强质量认证体系建设',
    '1',
    '2',
    '行业资讯',
    '23.docx'
  ),
  (
    '7',
    '国务院办公厅关于加强电梯质量安全工作的意见',
    '1',
    '2',
    '行业资讯',
    '24.doc'
  ),
  (
    '8',
    '中华人民共和国特种设备安全法',
    '2',
    '2',
    '法律法规',
    '25.doc'
  ),
  (
    '9',
    '特种设备安全监察条例',
    '2',
    '2',
    '法律法规',
    '26.docx'
  ),
  (
    '10',
    '特种设备使用管理规则',
    '2',
    '2',
    '法律法规',
    '28.pdf'
  ),
  (
    '11',
    '国务院关于加强质量认证体系建设',
    '1',
    '1',
    '行业资讯',
    '23.docx'
  ),
  (
    '12',
    '国务院办公厅关于加强电梯质量安全工作的意见',
    '1',
    '1',
    '行业资讯',
    '24.doc'
  ),
  (
    '13',
    '中华人民共和国特种设备安全法',
    '2',
    '1',
    '法律法规',
    '25.doc'
  ),
  (
    '14',
    '特种设备安全监察条例',
    '2',
    '1',
    '法律法规',
    '26.docx'
  ),
  (
    '15',
    '电梯维护保养规则',
    '2',
    '1',
    '法律法规',
    '29.docx'
  ),
  (
    '16',
    '电梯液压电梯非开门区困人应急救援方法',
    '3',
    '1',
    '工作资讯',
    '30.docx'
  ),
  (
    '17',
    '曳引式电梯/液压电梯非正常运行发生剪切事故应急救援方法',
    '3',
    '1',
    '工作资讯',
    '31.docx'
  ),
  (
    '18',
    '电梯制动器失效应急救援方法',
    '3',
    '1',
    '工作资讯',
    '32.docx'
  ),
  (
    '19',
    '安全钳意外动作应急救援方法',
    '3',
    '1',
    '工作资讯',
    '33.docx'
  ),
  (
    '20',
    '上行超速保护装置动作应急救援方法',
    '3',
    '1',
    '工作资讯',
    '34.docx'
  ),
  (
    '21',
    '自动扶梯、自动人行道发生夹持应急救援方法',
    '3',
    '1',
    '工作资讯',
    '35.docx'
  ),
  (
    '22',
    '自动扶梯自动人行道部件故障应急救援方法',
    '3',
    '1',
    '工作资讯',
    '36.docx'
  ),
  (
    '23',
    '火灾应急救援方法',
    '3',
    '1',
    '工作资讯',
    '37.docx'
  ),
  (
    '24',
    '大面积停电或自然灾害应急救援方法',
    '3',
    '1',
    '工作资讯',
    '38.docx'
  ),
  (
    '25',
    '有机房曳引式电梯紧急操作方法',
    '3',
    '1',
    '工作资讯',
    '39.docx'
  ),
  (
    '26',
    '无机房无齿轮曳引式电梯紧急操作方法',
    '3',
    '1',
    '工作资讯',
    '40.docx'
  ),
  (
    '27',
    '液压式升降电梯手动紧急操作方法',
    '3',
    '1',
    '工作资讯',
    '41.docx'
  ),
  (
    '28',
    '电梯液压电梯非开门区困人应急救援方法',
    '3',
    '2',
    '工作资讯',
    '30.docx'
  ),
  (
    '29',
    '曳引式电梯/液压电梯非正常运行发生剪切事故应急救援方法',
    '3',
    '2',
    '工作资讯',
    '31.docx'
  ),
  (
    '30',
    '电梯制动器失效应急救援方法',
    '3',
    '2',
    '工作资讯',
    '32.docx'
  ),
  (
    '31',
    '安全钳意外动作应急救援方法',
    '3',
    '2',
    '工作资讯',
    '33.docx'
  ),
  (
    '32',
    '上行超速保护装置动作应急救援方法',
    '3',
    '2',
    '工作资讯',
    '34.docx'
  ),
  (
    '33',
    '自动扶梯、自动人行道发生夹持应急救援方法',
    '3',
    '2',
    '工作资讯',
    '35.docx'
  ),
  (
    '34',
    '自动扶梯自动人行道部件故障应急救援方法',
    '3',
    '2',
    '工作资讯',
    '36.docx'
  ),
  (
    '35',
    '火灾应急救援方法',
    '3',
    '2',
    '工作资讯',
    '37.docx'
  ),
  (
    '36',
    '大面积停电或自然灾害应急救援方法',
    '3',
    '2',
    '工作资讯',
    '38.docx'
  ),
  (
    '37',
    '有机房曳引式电梯紧急操作方法',
    '3',
    '2',
    '工作资讯',
    '39.docx'
  ),
  (
    '38',
    '无机房无齿轮曳引式电梯紧急操作方法',
    '3',
    '2',
    '工作资讯',
    '40.docx'
  ),
  (
    '39',
    '液压式升降电梯手动紧急操作方法',
    '3',
    '2',
    '工作资讯',
    '41.docx'
  );

INSERT INTO CHECK_ITEM (ITEM_TYPE,ITEM_NAME,ITEM_NO,IS_USE,ITEM_CONTENT) VALUES
  ('1','生产单位现场','1001','1','检查许可证是否在有效期内'),
  ('1','生产单位现场','1002','1','抽查特种设备管理人员、检测人员、专业技术人员、作业人员是否具有相应资格'),
  ('1','生产单位现场','1003','1','抽查设计制造、安装、改造、重大修理档案是否建立'),
  ('1','生产单位现场','1004','1','抽查设计图样审批手续是否符合要求'),
  ('1','生产单位现场','1005','1','抽查产品生产过程资料是否保存完整，特种设备出厂是否附有质量合格证明等相关文件和资料，特种设备安装、改造、修理竣工后是否移交相关技术资料的文件'),
  ('1','生产单位现场','1006','1','抽查型式试验、监督检验资料是否齐全'),
  ('1','生产单位现场','1007','1','最近一次评审提出的整改项目是否整改'),
  ('1','生产单位现场','1008','1','抽查是否存在超出许可范围和许可有效期生产的情况'),
  ('1','生产单位现场','1009','1','检查生产单位法定代表人、名称、产权、生产场地等变更是否及时申请变更'),
  ('2','机构及制度','2001','1','是否设置安全管理机构或配备专兼职管理人员'),
  ('2','机构及制度','2003','1','是否按规定建立安全管理制度和岗位安全责任制度'),
  ('2','机构及制度','2003','1','是否制定事故应急专项预案并有演练记录'),
  ('2','设备档案','2004','1','是否建立设备档案，档案是否齐全'),
  ('2','设备档案','2005','1','所抽查设备是否在定期检验有效期内'),
  ('2','设备档案','2006','1','所抽查的设备是否按规定进行日常维护保养或者定期自行检查并有记录'),
  ('2','人员档案','2007','1','抽查安全管理人员和作业人员证件是否在有效期内'),
  ('2','人员档案','2008','1','是否有特种设备作业人员培训记录'),
  ('3','作业人员','3001','1','现场作业人员是否具有有效证件'),
  ('3','使用登记及警示标记','3002','1','是否有使用登记标志，并按规定固定在电梯的显著位置，是否在下次检验期限内'),
  ('3','使用登记及警示标记','3003','1','安全注意事项和警示标志是否置于易于为乘客注意的显著位置'),
  ('3','安全装置','3004','1','电梯内设置的报警装置是否可靠，联系是否畅通'),
  ('3','安全装置','3005','1','抽查呼层、楼层等显示信号系统功能是否有效，指示是否正确'),
  ('3','安全装置','3006','1','门防夹保护装置是否有效'),
  ('3','安全装置','3007','1','自动扶梯和自动人行道入口处急停开关是否有效'),
  ('3','安全装置','3008','1','限速器校验报告是否在有效期内'),
  ('3','维保情况','3009','1','是否有有效的维保合同，维保资质及人员资质是否满足要求'),
  ('3','维保情况','3010','1','是否有维保记录，并经安全管理人员签字确认，维保周期是否符合规定');


COMMIT;